Hệ thống quản lý trường học bằng PHP / MySQLi

1 <?php
2 include(
"connect.php");
3 ?>
4 <?php
5 require_once(
'session1.php');
6 ?>
7 <!--*****************Analysis data*****************************-->
8 <?php
9 SESSION_START();
10 ?>
11
12 <!DOCTYPE html>
13 <html>
14 <head>
15     <meta charset=
"utf-8">
16     <meta name=
"viewport" content="width=device-width, initial-scale=1.0">
17     <title>school management system</title>
18     <link rel=
"shortcut icon" href="assets/img/title.gif" type="image/x-icon">
19     <link rel=
"stylesheet" href="assets/css/bootstrap.min.css">
20     <link href=
"assets/css/loader.css" rel="stylesheet" />
21     <script src=
"assets/js/canvasjs.min.js"></script>
22     <!--*****jquery -
3.2.1.js file supports the use of dropdown***-->
23     <script src=
"assets/js/jquery-3.2.1.js"></script>
24
25
26 </head>
27 <!--<style type=
"text/css">
28     body{
29         margin-right: 10px;
30         margin-left: 10px;
31         }
32 </style>
33
34 -->
35
36 <body >
37 <!--end of heading section-->
38 <ul
class="nav navbar-right top-nav">
39     <div
class="dropdown">
40   <button
class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
41   <?php
42         
//Check to see if the user is logged in.if not redirect user to the loging page.
43         
44         
if(isset($_SESSION['fname']))
45         {
46         echo
"Current user: ".$_SESSION['fname']. "&nbsp;".$_SESSION['lname']. " ";
47         }
else{
48           echo
"<script type='text/javascript'>
49                     alert( 'You must Log
in to use the system');
50                     </script>"
;
51                 echo
"<script>
52                     window.location = 'index.php'
53                   </script>"
;
54         }
55         ?>
56   <span
class="caret"></span></button>
57   <ul
class="dropdown-menu">
58       <li><a href=
"manage_account.php"><i class="fa fa-users fa-lg"></i>&nbsp;View User</a></li>
59       <li><a href=
"register_form.php"><i class="fa fa-users fa-lg"></i>&nbsp;Add New User</a></li>
60       <li
class="divider"></li>
61       <li><a href=
"session_logout.php"><i class="fa fa-fw fa-power-off"></i>&nbsp;Log Out</a></li>
62   </ul>
63 </div>
64   </ul>
65 <!--************************************************-->
66 <div style=
"
67     font-family:Nyala, Arial;
68     text-align: left;
69     background-color: #526F35;
70     padding: 20px;
71     color:white;
72     width:
100%;
73     height: 150px;"
>
74     <!--This codes to load the image loader-->
75     <div id=
"loading">
76             <img id=
"loading-image" src="assets/img/loader.gif" alt="Loading..." />
77     </div>
78 <!--
this is the heading section-->
79     <h2>
80             <?php
81             $sql=
"SELECT * FROM companyinfo";
82             $result=mysqli_query($db,$sql) or die(
"error getting data");
83             $num_rows=mysqli_num_rows($result);
84              
while($row=mysqli_fetch_array($result))
85                     {
86                     echo
'<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
87                     $cname = $row[
'cname'];
88                      $cemail = $row[
'cemail'];
89                       $ccontact = $row[
'ccontact'];
90                        $clocation = $row[
'clocation'];
91                     }?>
92                     <?php
93                     echo $cname;
94                     ?>
95
96     <div style=
"float:right; font-size:20px;text-align:right;">
97     
98     <img src=
"assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
99     <img src=
"assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
100     <img src=
"assets/img/location.png">Location: <?php echo $clocation; ?>
101     
102     </div>
103    </h2>
104 </div>
105     <div>
106         <ul
class="nav nav-tabs">
107             <li
class="active"><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
108             <li ><a href=
"students.php" >Students <img src="assets/img/student48.png"></a></li>
109             <li><a href=
"staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
110             <li><a href=
"course.php" >Courses <img src="assets/img/course.png"></a></li>
111             <li><a href=
"departments.php" >Departments <img src="assets/img/department.png"></a></li>
112             <li><a href=
"markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
113             <li><a href=
"hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
114             <li><a href=
"sms.php">SMS <img src="assets/img/details.png"></a></li>
115             <!--<li><a href=
"tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
116             <li><a href=
"tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
117             
118         </ul>
119         <div
class="tab-content">
120             <div
class="tab-pane active" role="tabpanel" id="tab-1">
121                 
122                 <p>
123                     <div
class="table-responsive" >
124 <!--****************************************************************************-->
125                     <div
class="container" style="width:100%">
126                             
127                                 <ul
class="nav nav-tabs">
128                                   <li ><a href=
"register_form.php">New user <img src="assets/img/new.png"> </a></li>
129                                   <li
class="active"><a href="manage_account.php">View users<img src="assets/img/view2.png"></a></li>
130                               
131                                 </ul>
132                             <br>
133                             
134                         </div>
135 <!--****************************************************************************-->
136                         
137 <nav>
138         <center><h2>Manage Account<h2></center>
139         <div
class="col-sm-12">
140         <div
class="span7" id="">
141                      <div
class="row-fluid">
142             <?php
143                      $count_client=mysqli_query(
"select * from admin");
144                      $count = mysqli_num_rows($count_client);
145                        ?>
146                         <!-- block -->
147                         <div id=
"block_bg" class="block">
148                             <div
class="navbar navbar-inner block-header">
149               <br>
150                                 <div
class="muted pull-right">&nbsp;Admin List&nbsp;&nbsp;</div><div class="muted pull-right"><span class="label label-warning"><?php echo $count;?></span></div>
151                             
152                             <div
class="block-content collapse in">
153                                 <div
class="span12">
154                 
155                 <!-----------------------form --------------------->
156                 
157                     <table cellpadding=
"0" cellspacing="0" border="0" class="table" id="example">
158                   
159                     <thead>
160                       <tr>
161                         <th></th>
162                         <th>Name</th>
163                         <th>Username</th>
164                         <th>Edit</th>
165                         <script src=
"js/jquery.dataTables.min.js"></script>
166                                                 <script src=
"js/DT_bootstrap.js"></script>
167                         <th></th>
168                        </tr>
169                     </thead>
170                     <tbody>
171                           <?php
172                           $user_query = mysqli_query(
"select * from admin")or die(mysqli_error());
173                           
while($row = mysqli_fetch_array($user_query)){
174                           $id = $row[
'admin_id'];
175                           ?>
176                   
177                         <tr>
178                         <td width=
"30">
179                         </td>
180                         <td><?php echo $row[
'fname']; ?> <?php echo $row['lname']; ?></td>
181   
182                         <td><?php echo $row[
'username']; ?></td>
183                       
184                         <td
class="col-md-1">
185                         <a href=
"admin_edit.php <?php echo '?id='.$id; ?>" class="btn btn-success"><i class="glyphicon glyphicon-pencil"></i></a>
186                       
187               </tr>
188                         <?php } ?>
189                     </tbody>
190                   </table>
191                 </form>
192                   
193                                 </div>
194                             </div>
195                         </div>
196   
197 </div>
198             <!-- /.container-fluid -->
199
200         </div>
201         <!-- /#page-wrapper -->
202
203     </div>
204     </div>
205     </div>
206     </div>
207     </div>
208   </nav>
209     <!-- /#wrapper -->
210
211
212   <!--*********************************************************************************-->
213     <div
class="col-md-12" style="background-color:#526F35; position:fixed;bottom:0px;">
214         <p
class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
215     </div>
216
217     <script src=
"assets/js/jquery.min.js"></script>
218     <script src=
"assets/js/affix.js"></script>
219     <script src=
"assets/js/alert.js"></script>
220     <script src=
"assets/js/alert1.js"></script>
221     <script src=
"assets/js/bootstrap.js"></script>
222     <script src=
"assets/js/bootstrap.min.js"></script>
223     <script src=
"assets/js/bootstrap-datepicker.js"></script>
224     <script src=
"assets/js/bootstrap-wysihtml5.js"></script>
225     <script src=
"assets/js/button.js"></script>
226     <script src=
"assets/js/carousel.js"></script>
227     <script src=
"assets/js/chosen.jquery.min.js"></script>
228     <script src=
"assets/js/ckeditor.js"></script>
229     <script src=
"assets/js/collapse.js"></script>
230     <script src=
"assets/js/color.js"></script>
231     <script src=
"assets/js/dropdown.js"></script>
232     <script src=
"assets/js/DT_bootstrap.js"></script>
233     <script src=
"assets/js/dynamic.js"></script>
234     <script src=
"assets/js/ie-emulation-modes-warning.js"></script>
235     <script src=
"assets/js/jquery.dataTables.js"></script>
236     <script src=
"assets/js/jquery.dataTables.min.js"></script>
237     <script src=
"assets/js/jquery.dialog.js"></script>
238     <script src=
"assets/js/jquery.hoverdir.js"></script>
239     <script src=
"assets/js/jquery.jgrowl.js"></script>
240     <script src=
"assets/js/jquery.knob.js"></script>
241     <script src=
"assets/js/jquery.uniform.min.js"></script>
242     <script src=
"assets/js/jquery-1.8.3.min.js"></script>
243     <script src=
"assets/js/jquery-1.9.1.js"></script>
244     <script src=
"assets/js/jquery-1.9.1.min.js"></script>
245     <script src=
"assets/js/jquery-1.10.2.js"></script>
246     <script src=
"assets/js/jquery-1.11.0.js"></script>
247     <script src=
"assets/js/jquery-ui-1.9.2.custom.min.js"></script>
248     <script src=
"assets/js/jquery-ui-1.10.3.js"></script>
249     <script src=
"assets/js/modal.js"></script>
250     <script src=
"assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
251     <script src=
"assets/js/myjquery.js"></script>
252     <script src=
"assets/js/myjquery1.js"></script>
253     <script src=
"assets/js/npm.js"></script>
254     <script src=
"assets/js/popover.js"></script>
255     <script src=
"assets/js/profile.js"></script>
256     <script src=
"assets/js/raphael-min.js"></script>
257     <script src=
"assets/js/sb-admin-2.js"></script>
258     <script src=
"assets/js/scripts.js"></script>
259     <script src=
"assets/js/scrollspy.js"></script>
260     <script src=
"assets/js/tab.js"></script>
261     <script src=
"assets/js/tooltip.js"></script>
262     <script src=
"assets/js/transition.js"></script>
263     <script src=
"assets/js/wysihtml5-0.3.0.js"></script>
264     <script src=
"assets/js/slideshow.js"></script>
265
266     <script language=
"javascript" type="text/javascript">
267      $(window).load(function()
268       {
269         $(
'#loading').hide();
270       });
271 </script>
272
273 <script>
274 $(document).ready(function(){
275   $(
'.dropdown-submenu a.test').on("click", function(e){
276     $(
this).next('ul').toggle();
277     e.stopPropagation();
278     e.preventDefault();
279   });
280 });
281 </script>
282 </body>
283
284 </html>


Gõ tìm kiếm nhanh...